# """
# @Project:workflow_python
# @File:create.py
# @Author:袁浩天
# @Date:18:49
# """
# show tables;
# insert into department_tb values
# (1, "财务部", "2022-08-25 14:21", "", '0'),
# (2, "技术部", "2022-08-25 14:21", "", '0'),
# (3, "保安部", "2022-08-25 14:21", "", '0'),
# (4, "行政部", "2022-08-25 14:21", "", '0'),
# (5, "人事部", "2022-08-25 14:21", "", '0'),
# (6, "管理部", "2022-08-25 14:21", "", '0');
#
#
# insert into rank_tb values
# (1, "p1", "2022-8-26 14:32", "", '0'),
# (2, "p2", "2022-8-26 14:32", "", '0'),
# (3, "p3", "2022-8-26 14:32", "", '0'),
# (4, "p4", "2022-8-26 14:32", "", '0'),
# (5, "p5", "2022-8-26 14:32", "", '0'),
# (6, "p6", "2022-8-26 14:32", "", '0'),
# (7, "p7", "2022-8-26 14:32", "", '0'),
# (8, "p8", "2022-8-26 14:32", "", '0'),
# (9, "p9", "2022-8-26 14:32", "", '0'),
# (10, "p10", "2022-8-26 14:32", "", '0'),
# (11, "p11", "2022-8-26 14:32", "", '0'),
# (12, "p12", "2022-8-26 14:32", "", '0'),
# (13, "p13", "2022-8-26 14:32", "", '0'),
# (14, "p14", "2022-8-26 14:32", "", '0');
#
# insert into role_tb values
# (1, "管理者", "2022-08-28 16:03", "", '0'),
# (2, "财务部管理者", "2022-08-28 16:03", "", '0'),
# (3, "执行者", "2022-08-28 16:03", "", '0'),
# (4, "领导这", "2022-08-28 16:03", "", '0'),
# (5, "布道者", "2022-08-28 16:03", "", '0'),
# (6, "经营者", "2022-08-28 16:03", "", '0');
#
# insert into permission_tb values
# (1, "人事管理", "人事管理", "2022-08-28 16:03", 1, '0'),
# (2, "权限管理", "权限管理", "2022-08-28 16:03", 1, '0'),
# (3, "审批管理", "审批管理", "2022-08-28 16:03", 1, '0'),
# (4, "财产管理", "财产管理", "2022-08-28 16:03", 2, '0'),
# (5, "人事管理", "人事管理", "2022-08-28 16:03", 2, '0'),
# (6, "权限管理", "权限管理", "2022-08-28 16:03", 2, '0'),
# (7, "审批管理", "审批管理", "2022-08-28 16:03", 2, '0');
#
# insert into position_tb values
# (1, "财务员工", "2022-08-28 16:03", '0', 1, 1),
# (2, "技术员工", "2022-08-28 16:03", '0',2, 1),
# (3, "保安员工", "2022-08-28 16:03",'0', 3, 1),
# (4, "行政员工", "2022-08-28 16:03",'0', 4, 1),
# (5, "人事员工", "2022-08-28 16:03",'0', 5, 1),
# (6, "人事管理员", "2022-08-28 16:03",'0', 5, 6),
# (7, "财务管理员", "2022-08-28 16:03",'0', 1, 6),
# (8, "技术管理员", "2022-08-28 16:03",'0', 2, 6),
# (9, "行政管理员", "2022-08-28 16:03",'0', 4, 6),
# (10, "总经理", "2022-08-28 16:03", '0',6, 14);
#
# insert into position_role_tb values
# (1,'0', 1, 1),
# (2,'0', 2, 3),
# (3,'0', 3, 3),
# (4,'0', 4, 3),
# (5,'0', 5, 3),
# (6,'0', 6, 1),
# (7,'0', 7, 1),
# (8,'0', 8, 1),
# (9,'0', 9, 1),
# (10,'0', 10,4);
#
# insert into user_tb values
# (1, "鸣人", "mingren", "123456","13111111111", "2022-08-28 17:13", "北京","8", "男",3,"0", 1, 1),
# (2, "佐助", "zuozhu", "123456","13111111112", "2022-08-28 17:13", "北京","10", "男", 3,"0", 2, 1),
# (3, "桐人", "tongren", "123456","13111111113", "2022-08-28 17:13", "河南洛阳","12", "男",3,"0", 3, 1),
# (4, "亚斯娜", "yasina", "123456","13111111114", "2022-08-28 17:13", "河南洛阳","8", "女",3,"0", 4, 1),
# (5, "鼬", "you", "123456","13111111115", "2022-08-28 17:13", "北京","5", "男",3,"0", 5, 1),
# (6, "水门", "shuimen", "123456","13111111116", "2022-08-28 17:13", "北京","9", "男",3,"0", 6, 6),
# (7, "路飞", "lufei", "123456","13111111117", "2022-08-28 17:13", "西安", "7", "男",3,"0", 7, 6),
# (8, "索隆", "suolong", "123456","13111111118", "2022-08-28 17:13", "西安","6", "男",3,"0", 8, 6),
# (9, "亚索", "yasuo", "123456","13111111119", "2022-08-28 17:13", "上海","4", "男",3,"0", 9, 6),
# (10, "樱", "ying", "123456","13111111110", "2022-08-28 17:13", "上海","4", "女",3,"0", 10, 14);
#
# insert into menu_tb values
# (1, "首页", "", "", '0', null),
# (2, "基础配置", "", "",'0', null),
# (3, "配置工作流", "", "",'0',null),
# (4, "材料管理", "", "",'0', null),
# (5, "企业通讯", "", "",'0', null),
# (6, "合同管理", "", "",'0', null),
# (7, "OA审批", "", "",'0', null),
# (8, "用户管理", "", "",'0',2),
# (9, "角色管理", "", "",'0',2),
# (10, "权限管理", "", "",'0',2),
# (11, "菜单管理", "", "",'0',2),
# (12, "职级管理", "", "",'0',2),
# (13, "岗位管理", "", "",'0',2),
# (14, "操作日志", "", "",'0',2),
# (15, "登录日志", "", "",'0',2),
# (16, "字典管理", "", "",'0',2),
# (17, "部门管理", "", "",'0',2),
# (18, "配置审批流程", "", "",'0',3),
# (19, "配置审批类型", "", "",'0',3),
# (20, "材料管理", "", "",'0', 4),
# (21, "邮件处理", "", "",'0', 5),
# (22, "工资条录入", "", "",'0',5),
# (23, "待办事项", "", "",'0', 7),
# (24, "已办事项", "", "",'0', 7),
# (25, "我发起的", "", "",'0', 7);

































